package com.alks.function.data.dto.pcfactorywork;

import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.write.style.ColumnWidth;
import com.alibaba.excel.annotation.write.style.ContentRowHeight;
import com.alibaba.excel.annotation.write.style.HeadRowHeight;
import com.fasterxml.jackson.annotation.JsonFormat;
import lombok.Data;

import java.math.BigDecimal;
import java.time.LocalDateTime;

/**
 * 导出Excel
 */
@Data
@HeadRowHeight(value = 35) // 表头行高
@ContentRowHeight(value = 25) // 内容行高
//@HeadFontStyle      //表头样式
//@ContentFontStyle   //内容样式(字体名称、字体高度、是否斜体、是否设置删除水平线、字体颜色、下划线、是否加粗、编码格式、偏移量)
//@ColumnWidth(value = 50) 列宽（最大可设置到255）
//@ContentStyle
//@HeadStyle
public class PcDhPriceExcelDto {
    @ColumnWidth(20)
    @ExcelProperty(value = {"项目预算", "预算项目"}, index = 0, order = 1)
    private BigDecimal process;

    @ColumnWidth(20)
    @ExcelProperty(value = {"项目预算", "单价"}, index = 1, order = 2)
    private BigDecimal price;

    @ColumnWidth(40)
    @ExcelProperty(value = {"项目预算", "备注"}, index = 2, order = 3)
    private String remark;

    @ExcelProperty(value = {"项目预算", "建档日期"}, index = 3, order = 4)
    @JsonFormat(pattern = "yyyy-MM-dd",timezone = "GMT+8")
    private LocalDateTime sysDate;

    @ExcelProperty(value = "操作员", index = 4, order = 5)
    private String sysUser;
}
